Overview
Brought to you by YData
Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 43778 |
| Missing cells | 6 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 4.3 MiB |
| Average record size in memory | 104.0 B |
Variable types
| DateTime | 1 |
|---|---|
| Numeric | 11 |
DE_load_actual_entsoe_transparency is highly overall correlated with Price (EUR/MWhe) | High correlation |
DE_radiation_diffuse_horizontal is highly overall correlated with DE_radiation_direct_horizontal and 1 other fields | High correlation |
DE_radiation_direct_horizontal is highly overall correlated with DE_radiation_diffuse_horizontal and 2 other fields | High correlation |
DE_solar_capacity is highly overall correlated with DE_wind_capacity and 1 other fields | High correlation |
DE_solar_generation_actual is highly overall correlated with DE_radiation_diffuse_horizontal and 2 other fields | High correlation |
DE_temperature is highly overall correlated with DE_radiation_direct_horizontal and 1 other fields | High correlation |
DE_wind_capacity is highly overall correlated with DE_solar_capacity and 1 other fields | High correlation |
Oil_Price is highly overall correlated with DE_solar_capacity and 1 other fields | High correlation |
Price (EUR/MWhe) is highly overall correlated with DE_load_actual_entsoe_transparency | High correlation |
cet_cest_timestamp has unique values | Unique |
DE_solar_generation_actual has 18985 (43.4%) zeros | Zeros |
DE_radiation_direct_horizontal has 18724 (42.8%) zeros | Zeros |
DE_radiation_diffuse_horizontal has 18724 (42.8%) zeros | Zeros |
Reproduction
| Analysis started | 2025-04-21 14:29:10.913747 |
|---|---|
| Analysis finished | 2025-04-21 14:29:44.929787 |
| Duration | 34.02 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
Variables
Unique 
| Distinct | 43778 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 684.0 KiB |
| Minimum | 2015-01-01 00:00:00+01:00 |
|---|---|
| Maximum | 2019-12-30 01:00:00+01:00 |
| Invalid dates | 25704 |
| Invalid dates (%) | 58.7% |
DE_load_actual_entsoe_transparency
Real number (ℝ)
High correlation 
| Distinct | 25332 |
|---|---|
| Distinct (%) | 57.9% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 55867.097 |
| Minimum | 31307 |
|---|---|
| Maximum | 77549 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 684.0 KiB |
Quantile statistics
| Minimum | 31307 |
|---|---|
| 5-th percentile | 40239.8 |
| Q1 | 47440 |
| median | 55484 |
| Q3 | 64796 |
| 95-th percentile | 70968.2 |
| Maximum | 77549 |
| Range | 46242 |
| Interquartile range (IQR) | 17356 |
Descriptive statistics
| Standard deviation | 10006.677 |
|---|---|
| Coefficient of variation (CV) | 0.17911574 |
| Kurtosis | -1.1320954 |
| Mean | 55867.097 |
| Median Absolute Deviation (MAD) | 8680 |
| Skewness | -0.034148836 |
| Sum | 2.4456939 × 109 |
| Variance | 1.0013358 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 46724 | 8 | < 0.1% |
| 45129 | 8 | < 0.1% |
| 66809 | 7 | < 0.1% |
| 63092 | 7 | < 0.1% |
| 47964 | 7 | < 0.1% |
| 58055 | 7 | < 0.1% |
| 53534 | 7 | < 0.1% |
| 51016 | 7 | < 0.1% |
| 44841 | 7 | < 0.1% |
| 42851 | 7 | < 0.1% |
| Other values (25322) | 43705 |
| Value | Count | Frequency (%) |
| 31307 | 1 | |
| 31335 | 1 | |
| 31598 | 1 | |
| 31772 | 1 | |
| 32418 | 1 | |
| 32617 | 1 | |
| 32625 | 1 | |
| 32636 | 1 | |
| 32824 | 1 | |
| 32889 | 1 |
| Value | Count | Frequency (%) |
| 77549 | 1 | |
| 76925 | 1 | |
| 76904 | 1 | |
| 76871 | 1 | |
| 76783 | 1 | |
| 76602 | 1 | |
| 76574 | 1 | |
| 76552 | 1 | |
| 76551 | 1 | |
| 76538 | 1 |
DE_solar_capacity
Real number (ℝ)
High correlation 
| Distinct | 1464 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 42373.93 |
| Minimum | 37248 |
|---|---|
| Maximum | 50508 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 684.0 KiB |
Quantile statistics
| Minimum | 37248 |
|---|---|
| 5-th percentile | 37531 |
| Q1 | 38810 |
| median | 40941 |
| Q3 | 46092 |
| 95-th percentile | 50169 |
| Maximum | 50508 |
| Range | 13260 |
| Interquartile range (IQR) | 7282 |
Descriptive statistics
| Standard deviation | 4303.6143 |
|---|---|
| Coefficient of variation (CV) | 0.10156279 |
| Kurtosis | -0.98120024 |
| Mean | 42373.93 |
| Median Absolute Deviation (MAD) | 2513 |
| Skewness | 0.68489035 |
| Sum | 1.8550459 × 109 |
| Variance | 18521096 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 37531 | 120 | 0.3% |
| 38789 | 119 | 0.3% |
| 49191 | 96 | 0.2% |
| 41702 | 96 | 0.2% |
| 50507 | 96 | 0.2% |
| 37367 | 96 | 0.2% |
| 37649 | 96 | 0.2% |
| 39942 | 96 | 0.2% |
| 37372 | 96 | 0.2% |
| 39374 | 96 | 0.2% |
| Other values (1454) | 42771 |
| Value | Count | Frequency (%) |
| 37248 | 24 | 0.1% |
| 37250 | 72 | |
| 37252 | 24 | 0.1% |
| 37253 | 24 | 0.1% |
| 37256 | 24 | 0.1% |
| 37258 | 24 | 0.1% |
| 37260 | 72 | |
| 37263 | 24 | 0.1% |
| 37264 | 24 | 0.1% |
| 37266 | 24 | 0.1% |
| Value | Count | Frequency (%) |
| 50508 | 74 | |
| 50507 | 96 | |
| 50506 | 48 | |
| 50505 | 24 | 0.1% |
| 50502 | 24 | 0.1% |
| 50499 | 24 | 0.1% |
| 50485 | 24 | 0.1% |
| 50481 | 24 | 0.1% |
| 50479 | 72 | |
| 50478 | 24 | 0.1% |
DE_solar_generation_actual
Real number (ℝ)
High correlation  Zeros 
| Distinct | 13490 |
|---|---|
| Distinct (%) | 30.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4303.0678 |
| Minimum | 0 |
|---|---|
| Maximum | 30028 |
| Zeros | 18985 |
| Zeros (%) | 43.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 684.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 126 |
| Q3 | 6818 |
| 95-th percentile | 19359.15 |
| Maximum | 30028 |
| Range | 30028 |
| Interquartile range (IQR) | 6818 |
Descriptive statistics
| Standard deviation | 6601.6531 |
|---|---|
| Coefficient of variation (CV) | 1.5341736 |
| Kurtosis | 1.4031231 |
| Mean | 4303.0678 |
| Median Absolute Deviation (MAD) | 126 |
| Skewness | 1.5564744 |
| Sum | 1.883797 × 108 |
| Variance | 43581824 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 18985 | |
| 1 | 280 | 0.6% |
| 2 | 181 | 0.4% |
| 3 | 147 | 0.3% |
| 4 | 99 | 0.2% |
| 5 | 90 | 0.2% |
| 6 | 64 | 0.1% |
| 7 | 64 | 0.1% |
| 8 | 58 | 0.1% |
| 9 | 45 | 0.1% |
| Other values (13480) | 23765 |
| Value | Count | Frequency (%) |
| 0 | 18985 | |
| 0.5 | 1 | < 0.1% |
| 1 | 280 | 0.6% |
| 1.5 | 1 | < 0.1% |
| 2 | 181 | 0.4% |
| 3 | 147 | 0.3% |
| 4 | 99 | 0.2% |
| 5 | 90 | 0.2% |
| 6 | 64 | 0.1% |
| 7 | 64 | 0.1% |
| Value | Count | Frequency (%) |
| 30028 | 1 | |
| 29967 | 1 | |
| 29913 | 1 | |
| 29849 | 1 | |
| 29813 | 1 | |
| 29722 | 1 | |
| 29708 | 1 | |
| 29685 | 1 | |
| 29651 | 1 | |
| 29624 | 1 |
DE_wind_capacity
Real number (ℝ)
High correlation 
| Distinct | 1367 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 39967.34 |
| Minimum | 27913 |
|---|---|
| Maximum | 50452 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 684.0 KiB |
Quantile statistics
| Minimum | 27913 |
|---|---|
| 5-th percentile | 28882 |
| Q1 | 33737 |
| median | 39808 |
| Q3 | 47730 |
| 95-th percentile | 50059 |
| Maximum | 50452 |
| Range | 22539 |
| Interquartile range (IQR) | 13993 |
Descriptive statistics
| Standard deviation | 7260.8091 |
|---|---|
| Coefficient of variation (CV) | 0.18166856 |
| Kurtosis | -1.3866005 |
| Mean | 39967.34 |
| Median Absolute Deviation (MAD) | 6685 |
| Skewness | -0.02370818 |
| Sum | 1.7496902 × 109 |
| Variance | 52719349 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 44841 | 264 | 0.6% |
| 48974 | 192 | 0.4% |
| 48249 | 168 | 0.4% |
| 49364 | 168 | 0.4% |
| 49429 | 144 | 0.3% |
| 49300 | 144 | 0.3% |
| 49014 | 144 | 0.3% |
| 50074 | 144 | 0.3% |
| 49370 | 144 | 0.3% |
| 32812 | 144 | 0.3% |
| Other values (1357) | 42122 |
| Value | Count | Frequency (%) |
| 27913 | 24 | 0.1% |
| 27926 | 72 | |
| 27939 | 24 | 0.1% |
| 27950 | 24 | 0.1% |
| 27957 | 24 | 0.1% |
| 27966 | 24 | 0.1% |
| 27972 | 72 | |
| 27976 | 24 | 0.1% |
| 27982 | 24 | 0.1% |
| 27988 | 48 |
| Value | Count | Frequency (%) |
| 50452 | 2 | < 0.1% |
| 50434 | 24 | 0.1% |
| 50427 | 48 | |
| 50424 | 96 | |
| 50409 | 24 | 0.1% |
| 50403 | 24 | 0.1% |
| 50399 | 24 | 0.1% |
| 50370 | 24 | 0.1% |
| 50361 | 24 | 0.1% |
| 50345 | 24 | 0.1% |
DE_wind_generation_actual
Real number (ℝ)
| Distinct | 21472 |
|---|---|
| Distinct (%) | 49.0% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11147.869 |
| Minimum | 135 |
|---|---|
| Maximum | 45085 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 684.0 KiB |
Quantile statistics
| Minimum | 135 |
|---|---|
| 5-th percentile | 1494 |
| Q1 | 4423 |
| median | 8726 |
| Q3 | 15562 |
| 95-th percentile | 29300.2 |
| Maximum | 45085 |
| Range | 44950 |
| Interquartile range (IQR) | 11139 |
Descriptive statistics
| Standard deviation | 8682.6073 |
|---|---|
| Coefficient of variation (CV) | 0.77885803 |
| Kurtosis | 0.77542329 |
| Mean | 11147.869 |
| Median Absolute Deviation (MAD) | 5041 |
| Skewness | 1.1340622 |
| Sum | 4.8802026 × 108 |
| Variance | 75387669 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3879 | 10 | < 0.1% |
| 3336 | 10 | < 0.1% |
| 4853 | 10 | < 0.1% |
| 3165 | 10 | < 0.1% |
| 7892 | 10 | < 0.1% |
| 4506 | 9 | < 0.1% |
| 4207 | 9 | < 0.1% |
| 4826 | 9 | < 0.1% |
| 2477 | 9 | < 0.1% |
| 2952 | 9 | < 0.1% |
| Other values (21462) | 43682 |
| Value | Count | Frequency (%) |
| 135 | 1 | |
| 153 | 2 | |
| 163 | 1 | |
| 165 | 1 | |
| 177 | 1 | |
| 189 | 1 | |
| 192 | 1 | |
| 203 | 2 | |
| 205 | 1 | |
| 207 | 1 |
| Value | Count | Frequency (%) |
| 45085 | 1 | |
| 45058 | 1 | |
| 44629 | 1 | |
| 44503 | 1 | |
| 44367 | 1 | |
| 44350 | 1 | |
| 44226 | 1 | |
| 44192 | 1 | |
| 44089 | 1 | |
| 43870 | 1 |
Price (EUR/MWhe)
Real number (ℝ)
High correlation 
| Distinct | 7314 |
|---|---|
| Distinct (%) | 16.7% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35.2341 |
| Minimum | -130.09 |
|---|---|
| Maximum | 163.52 |
| Zeros | 7 |
| Zeros (%) | < 0.1% |
| Negative | 646 |
| Negative (%) | 1.5% |
| Memory size | 684.0 KiB |
Quantile statistics
| Minimum | -130.09 |
|---|---|
| 5-th percentile | 12.03 |
| Q1 | 27.06 |
| median | 34.93 |
| Q3 | 43.82 |
| 95-th percentile | 58.12 |
| Maximum | 163.52 |
| Range | 293.61 |
| Interquartile range (IQR) | 16.76 |
Descriptive statistics
| Standard deviation | 15.387706 |
|---|---|
| Coefficient of variation (CV) | 0.43672766 |
| Kurtosis | 6.2495879 |
| Mean | 35.2341 |
| Median Absolute Deviation (MAD) | 8.27 |
| Skewness | -0.22802057 |
| Sum | 1542443.2 |
| Variance | 236.7815 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 22.34 | 105 | 0.2% |
| 40 | 58 | 0.1% |
| 30 | 56 | 0.1% |
| 35 | 53 | 0.1% |
| 34.94 | 50 | 0.1% |
| 39.9 | 42 | 0.1% |
| 42 | 41 | 0.1% |
| 33 | 39 | 0.1% |
| 34.9 | 39 | 0.1% |
| 32 | 39 | 0.1% |
| Other values (7304) | 43255 |
| Value | Count | Frequency (%) |
| -130.09 | 1 | |
| -100.06 | 1 | |
| -83.06 | 1 | |
| -83.04 | 1 | |
| -83.03 | 1 | |
| -83.02 | 1 | |
| -83.01 | 1 | |
| -83 | 2 | |
| -82.06 | 1 | |
| -81.95 | 1 |
| Value | Count | Frequency (%) |
| 163.52 | 1 | |
| 153.67 | 1 | |
| 151.07 | 1 | |
| 150.1 | 1 | |
| 143.09 | 1 | |
| 142.78 | 1 | |
| 138.91 | 1 | |
| 135 | 1 | |
| 133.18 | 1 | |
| 131.01 | 1 |
DE_temperature
Real number (ℝ)
High correlation 
| Distinct | 23390 |
|---|---|
| Distinct (%) | 53.4% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.8602105 |
| Minimum | -12.686 |
|---|---|
| Maximum | 35.479 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 4663 |
| Negative (%) | 10.7% |
| Memory size | 684.0 KiB |
Quantile statistics
| Minimum | -12.686 |
|---|---|
| 5-th percentile | -1.983 |
| Q1 | 3.273 |
| median | 9.249 |
| Q3 | 16.034 |
| 95-th percentile | 23.631 |
| Maximum | 35.479 |
| Range | 48.165 |
| Interquartile range (IQR) | 12.761 |
Descriptive statistics
| Standard deviation | 8.1292512 |
|---|---|
| Coefficient of variation (CV) | 0.82445006 |
| Kurtosis | -0.65315928 |
| Mean | 9.8602105 |
| Median Absolute Deviation (MAD) | 6.334 |
| Skewness | 0.23866449 |
| Sum | 431650.44 |
| Variance | 66.084725 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6.99 | 9 | < 0.1% |
| 16.978 | 8 | < 0.1% |
| 12.66 | 8 | < 0.1% |
| 4.291 | 8 | < 0.1% |
| 13.112 | 8 | < 0.1% |
| 3.262 | 8 | < 0.1% |
| 9.167 | 7 | < 0.1% |
| 4.532 | 7 | < 0.1% |
| 1.202 | 7 | < 0.1% |
| 1.76 | 7 | < 0.1% |
| Other values (23380) | 43700 |
| Value | Count | Frequency (%) |
| -12.686 | 1 | |
| -12.507 | 1 | |
| -12.353 | 1 | |
| -11.988 | 1 | |
| -11.619 | 1 | |
| -11.212 | 1 | |
| -11.146 | 1 | |
| -11.062 | 1 | |
| -11.027 | 1 | |
| -10.955 | 1 |
| Value | Count | Frequency (%) |
| 35.479 | 1 | |
| 35.374 | 1 | |
| 35.248 | 1 | |
| 34.952 | 1 | |
| 34.713 | 1 | |
| 34.373 | 1 | |
| 34.317 | 1 | |
| 34.298 | 1 | |
| 34.176 | 1 | |
| 34.172 | 1 |
DE_radiation_direct_horizontal
Real number (ℝ)
High correlation  Zeros 
| Distinct | 25054 |
|---|---|
| Distinct (%) | 57.2% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 82.819672 |
| Minimum | 0 |
|---|---|
| Maximum | 841.68104 |
| Zeros | 18724 |
| Zeros (%) | 42.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 684.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.42644003 |
| Q3 | 79.325396 |
| 95-th percentile | 475.45788 |
| Maximum | 841.68104 |
| Range | 841.68104 |
| Interquartile range (IQR) | 79.325396 |
Descriptive statistics
| Standard deviation | 159.06547 |
|---|---|
| Coefficient of variation (CV) | 1.9206242 |
| Kurtosis | 4.310132 |
| Mean | 82.819672 |
| Median Absolute Deviation (MAD) | 0.42644003 |
| Skewness | 2.2263327 |
| Sum | 3625596.8 |
| Variance | 25301.823 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 18724 | |
| 7.95798668 | 1 | < 0.1% |
| 9.379364792 | 1 | < 0.1% |
| 3.822047998 | 1 | < 0.1% |
| 70.51504672 | 1 | < 0.1% |
| 18.89479469 | 1 | < 0.1% |
| 10.5469209 | 1 | < 0.1% |
| 0.2799298852 | 1 | < 0.1% |
| 0.4327949255 | 1 | < 0.1% |
| 8.877348817 | 1 | < 0.1% |
| Other values (25044) | 25044 |
| Value | Count | Frequency (%) |
| 0 | 18724 | |
| 8.171790981 × 10-7 | 1 | < 0.1% |
| 9.07846013 × 10-7 | 1 | < 0.1% |
| 9.530085836 × 10-7 | 1 | < 0.1% |
| 1.045591789 × 10-6 | 1 | < 0.1% |
| 1.06322559 × 10-6 | 1 | < 0.1% |
| 1.07193191 × 10-6 | 1 | < 0.1% |
| 1.14164887 × 10-6 | 1 | < 0.1% |
| 1.141725265 × 10-6 | 1 | < 0.1% |
| 1.173996657 × 10-6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 841.6810378 | 1 | |
| 841.2403306 | 1 | |
| 840.6881976 | 1 | |
| 831.5056881 | 1 | |
| 829.7901916 | 1 | |
| 827.1609402 | 1 | |
| 822.3007002 | 1 | |
| 818.5285918 | 1 | |
| 814.5623326 | 1 | |
| 813.3931179 | 1 |
DE_radiation_diffuse_horizontal
Real number (ℝ)
High correlation  Zeros 
| Distinct | 25054 |
|---|---|
| Distinct (%) | 57.2% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 67.120673 |
| Minimum | 0 |
|---|---|
| Maximum | 392.08953 |
| Zeros | 18724 |
| Zeros (%) | 42.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 684.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 6.3509196 |
| Q3 | 119.66999 |
| 95-th percentile | 254.93552 |
| Maximum | 392.08953 |
| Range | 392.08953 |
| Interquartile range (IQR) | 119.66999 |
Descriptive statistics
| Standard deviation | 89.201568 |
|---|---|
| Coefficient of variation (CV) | 1.3289731 |
| Kurtosis | 0.74047776 |
| Mean | 67.120673 |
| Median Absolute Deviation (MAD) | 6.3509196 |
| Skewness | 1.2607732 |
| Sum | 2938341.7 |
| Variance | 7956.9197 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 18724 | |
| 100.6625133 | 1 | < 0.1% |
| 108.5543352 | 1 | < 0.1% |
| 45.275952 | 1 | < 0.1% |
| 81.73645328 | 1 | < 0.1% |
| 51.04470531 | 1 | < 0.1% |
| 112.3496791 | 1 | < 0.1% |
| 2.273970115 | 1 | < 0.1% |
| 6.768005075 | 1 | < 0.1% |
| 51.94635118 | 1 | < 0.1% |
| Other values (25044) | 25044 |
| Value | Count | Frequency (%) |
| 0 | 18724 | |
| 8.675676469 × 10-5 | 1 | < 0.1% |
| 8.78007015 × 10-5 | 1 | < 0.1% |
| 8.7845987 × 10-5 | 1 | < 0.1% |
| 8.795196726 × 10-5 | 1 | < 0.1% |
| 9.074600853 × 10-5 | 1 | < 0.1% |
| 9.07794107 × 10-5 | 1 | < 0.1% |
| 9.173733963 × 10-5 | 1 | < 0.1% |
| 9.225912742 × 10-5 | 1 | < 0.1% |
| 9.230272995 × 10-5 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 392.0895324 | 1 | |
| 390.2950449 | 1 | |
| 389.785004 | 1 | |
| 389.722721 | 1 | |
| 387.7550278 | 1 | |
| 385.454346 | 1 | |
| 384.7493436 | 1 | |
| 384.68629 | 1 | |
| 384.6193791 | 1 | |
| 384.2284195 | 1 |
Gas_Price
Real number (ℝ)
| Distinct | 220 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.7684353 |
| Minimum | 1.49 |
|---|---|
| Maximum | 6.24 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 684.0 KiB |
Quantile statistics
| Minimum | 1.49 |
|---|---|
| 5-th percentile | 1.91 |
| Q1 | 2.54 |
| median | 2.79 |
| Q3 | 2.98 |
| 95-th percentile | 3.56 |
| Maximum | 6.24 |
| Range | 4.75 |
| Interquartile range (IQR) | 0.44 |
Descriptive statistics
| Standard deviation | 0.50564694 |
|---|---|
| Coefficient of variation (CV) | 0.1826472 |
| Kurtosis | 4.5642933 |
| Mean | 2.7684353 |
| Median Absolute Deviation (MAD) | 0.21 |
| Skewness | 0.92941831 |
| Sum | 121196.56 |
| Variance | 0.25567883 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.88 | 1200 | 2.7% |
| 2.75 | 1104 | 2.5% |
| 2.96 | 912 | 2.1% |
| 2.89 | 816 | 1.9% |
| 2.76 | 768 | 1.8% |
| 2.7 | 720 | 1.6% |
| 2.95 | 672 | 1.5% |
| 2.98 | 672 | 1.5% |
| 2.78 | 672 | 1.5% |
| 2.91 | 672 | 1.5% |
| Other values (210) | 35570 |
| Value | Count | Frequency (%) |
| 1.49 | 72 | |
| 1.56 | 24 | 0.1% |
| 1.57 | 24 | 0.1% |
| 1.59 | 24 | 0.1% |
| 1.6 | 48 | 0.1% |
| 1.61 | 24 | 0.1% |
| 1.62 | 24 | 0.1% |
| 1.63 | 120 | |
| 1.66 | 24 | 0.1% |
| 1.68 | 24 | 0.1% |
| Value | Count | Frequency (%) |
| 6.24 | 48 | 0.1% |
| 5.46 | 24 | 0.1% |
| 4.7 | 120 | |
| 4.69 | 48 | 0.1% |
| 4.65 | 144 | |
| 4.61 | 72 | |
| 4.54 | 24 | 0.1% |
| 4.53 | 48 | 0.1% |
| 4.51 | 72 | |
| 4.5 | 48 | 0.1% |
Oil_Price
Real number (ℝ)
High correlation 
| Distinct | 1064 |
|---|---|
| Distinct (%) | 2.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 57.09679 |
| Minimum | 26.01 |
|---|---|
| Maximum | 86.07 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 684.0 KiB |
Quantile statistics
| Minimum | 26.01 |
|---|---|
| 5-th percentile | 37.22 |
| Q1 | 48.1 |
| median | 57.02 |
| Q3 | 65.02 |
| 95-th percentile | 75.89 |
| Maximum | 86.07 |
| Range | 60.06 |
| Interquartile range (IQR) | 16.92 |
Descriptive statistics
| Standard deviation | 11.529101 |
|---|---|
| Coefficient of variation (CV) | 0.20192206 |
| Kurtosis | -0.480539 |
| Mean | 57.09679 |
| Median Absolute Deviation (MAD) | 8.53 |
| Skewness | -0.039511655 |
| Sum | 2499583.3 |
| Variance | 132.92018 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 54.8 | 168 | 0.4% |
| 46.69 | 168 | 0.4% |
| 55.73 | 144 | 0.3% |
| 70.71 | 144 | 0.3% |
| 64.68 | 144 | 0.3% |
| 69.02 | 144 | 0.3% |
| 61.04 | 144 | 0.3% |
| 47.28 | 144 | 0.3% |
| 51.93 | 144 | 0.3% |
| 38.33 | 120 | 0.3% |
| Other values (1054) | 42314 |
| Value | Count | Frequency (%) |
| 26.01 | 24 | 0.1% |
| 27.36 | 48 | |
| 27.59 | 24 | 0.1% |
| 28.58 | 24 | 0.1% |
| 28.8 | 72 | |
| 28.82 | 24 | 0.1% |
| 28.84 | 24 | 0.1% |
| 29.14 | 24 | 0.1% |
| 29.64 | 24 | 0.1% |
| 29.82 | 24 | 0.1% |
| Value | Count | Frequency (%) |
| 86.07 | 24 | 0.1% |
| 85.63 | 24 | 0.1% |
| 85.45 | 24 | 0.1% |
| 85.16 | 24 | 0.1% |
| 85.12 | 72 | |
| 84.94 | 24 | 0.1% |
| 84.22 | 24 | 0.1% |
| 83.82 | 24 | 0.1% |
| 82.72 | 72 | |
| 82.21 | 24 | 0.1% |
Interactions
Correlations
| DE_load_actual_entsoe_transparency | DE_radiation_diffuse_horizontal | DE_radiation_direct_horizontal | DE_solar_capacity | DE_solar_generation_actual | DE_temperature | DE_wind_capacity | DE_wind_generation_actual | Gas_Price | Oil_Price | Price (EUR/MWhe) | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| DE_load_actual_entsoe_transparency | 1.000 | 0.457 | 0.443 | 0.044 | 0.454 | -0.054 | 0.043 | 0.071 | 0.060 | 0.023 | 0.545 |
| DE_radiation_diffuse_horizontal | 0.457 | 1.000 | 0.941 | -0.014 | 0.951 | 0.470 | -0.014 | -0.150 | -0.031 | 0.023 | 0.107 |
| DE_radiation_direct_horizontal | 0.443 | 0.941 | 1.000 | -0.007 | 0.985 | 0.507 | -0.007 | -0.206 | -0.028 | 0.046 | 0.102 |
| DE_solar_capacity | 0.044 | -0.014 | -0.007 | 1.000 | 0.010 | 0.080 | 1.000 | 0.227 | 0.076 | 0.644 | 0.336 |
| DE_solar_generation_actual | 0.454 | 0.951 | 0.985 | 0.010 | 1.000 | 0.502 | 0.010 | -0.183 | -0.034 | 0.049 | 0.093 |
| DE_temperature | -0.054 | 0.470 | 0.507 | 0.080 | 0.502 | 1.000 | 0.080 | -0.243 | -0.037 | 0.083 | -0.037 |
| DE_wind_capacity | 0.043 | -0.014 | -0.007 | 1.000 | 0.010 | 0.080 | 1.000 | 0.227 | 0.076 | 0.644 | 0.336 |
| DE_wind_generation_actual | 0.071 | -0.150 | -0.206 | 0.227 | -0.183 | -0.243 | 0.227 | 1.000 | 0.024 | 0.122 | -0.274 |
| Gas_Price | 0.060 | -0.031 | -0.028 | 0.076 | -0.034 | -0.037 | 0.076 | 0.024 | 1.000 | 0.255 | 0.231 |
| Oil_Price | 0.023 | 0.023 | 0.046 | 0.644 | 0.049 | 0.083 | 0.644 | 0.122 | 0.255 | 1.000 | 0.359 |
| Price (EUR/MWhe) | 0.545 | 0.107 | 0.102 | 0.336 | 0.093 | -0.037 | 0.336 | -0.274 | 0.231 | 0.359 | 1.000 |
Missing values
Sample
| cet_cest_timestamp | DE_load_actual_entsoe_transparency | DE_solar_capacity | DE_solar_generation_actual | DE_wind_capacity | DE_wind_generation_actual | Price (EUR/MWhe) | DE_temperature | DE_radiation_direct_horizontal | DE_radiation_diffuse_horizontal | Gas_Price | Oil_Price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| utc_timestamp | ||||||||||||
| 2014-12-31 23:00:00 | 2015-01-01T00:00:00+0100 | NaN | 37248.0 | 0.0 | 27913.0 | NaN | NaN | NaN | NaN | NaN | 3.14 | 55.38 |
| 2015-01-01 00:00:00 | 2015-01-01T01:00:00+0100 | 41151.0 | 37248.0 | 0.0 | 27913.0 | 8852.0 | 22.34 | -0.981 | 0.000000 | 0.000000 | 3.14 | 55.38 |
| 2015-01-01 01:00:00 | 2015-01-01T02:00:00+0100 | 40135.0 | 37248.0 | 0.0 | 27913.0 | 9054.0 | 22.34 | -1.035 | 0.000000 | 0.000000 | 3.14 | 55.38 |
| 2015-01-01 02:00:00 | 2015-01-01T03:00:00+0100 | 39106.0 | 37248.0 | 0.0 | 27913.0 | 9070.0 | 22.34 | -1.109 | 0.000000 | 0.000000 | 3.14 | 55.38 |
| 2015-01-01 03:00:00 | 2015-01-01T04:00:00+0100 | 38765.0 | 37248.0 | 0.0 | 27913.0 | 9163.0 | 22.34 | -1.166 | 0.000000 | 0.000000 | 3.14 | 55.38 |
| 2015-01-01 04:00:00 | 2015-01-01T05:00:00+0100 | 38941.0 | 37248.0 | 0.0 | 27913.0 | 9231.0 | 22.34 | -1.226 | 0.000000 | 0.000000 | 3.14 | 55.38 |
| 2015-01-01 05:00:00 | 2015-01-01T06:00:00+0100 | 39045.0 | 37248.0 | 0.0 | 27913.0 | 9689.0 | 22.34 | -1.305 | 0.000000 | 0.000000 | 3.14 | 55.38 |
| 2015-01-01 06:00:00 | 2015-01-01T07:00:00+0100 | 40206.0 | 37248.0 | 0.0 | 27913.0 | 10331.0 | 22.34 | -1.478 | 0.000000 | 0.000000 | 3.14 | 55.38 |
| 2015-01-01 07:00:00 | 2015-01-01T08:00:00+0100 | 41133.0 | 37248.0 | 71.0 | 27913.0 | 10208.0 | 22.34 | -1.692 | 0.432795 | 6.768005 | 3.14 | 55.38 |
| 2015-01-01 08:00:00 | 2015-01-01T09:00:00+0100 | 42963.0 | 37248.0 | 773.0 | 27913.0 | 10029.0 | 22.34 | -1.046 | 8.877349 | 51.946351 | 3.14 | 55.38 |
| cet_cest_timestamp | DE_load_actual_entsoe_transparency | DE_solar_capacity | DE_solar_generation_actual | DE_wind_capacity | DE_wind_generation_actual | Price (EUR/MWhe) | DE_temperature | DE_radiation_direct_horizontal | DE_radiation_diffuse_horizontal | Gas_Price | Oil_Price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| utc_timestamp | ||||||||||||
| 2019-12-29 15:00:00 | 2019-12-29T16:00:00+0100 | 49244.0 | 50508.0 | 105.0 | 50434.0 | 14808.0 | 34.47 | -0.929 | 0.27993 | 2.27397 | 1.75 | 68.91 |
| 2019-12-29 16:00:00 | 2019-12-29T17:00:00+0100 | 52332.0 | 50508.0 | 0.0 | 50434.0 | 16721.0 | 39.81 | -0.982 | 0.00000 | 0.00000 | 1.75 | 68.91 |
| 2019-12-29 17:00:00 | 2019-12-29T18:00:00+0100 | 52958.0 | 50508.0 | 0.0 | 50434.0 | 18357.0 | 40.47 | -0.873 | 0.00000 | 0.00000 | 1.75 | 68.91 |
| 2019-12-29 18:00:00 | 2019-12-29T19:00:00+0100 | 51943.0 | 50508.0 | 0.0 | 50434.0 | 19397.0 | 38.96 | -0.880 | 0.00000 | 0.00000 | 1.75 | 68.91 |
| 2019-12-29 19:00:00 | 2019-12-29T20:00:00+0100 | 49806.0 | 50508.0 | 0.0 | 50434.0 | 19506.0 | 35.35 | -0.959 | 0.00000 | 0.00000 | 1.75 | 68.91 |
| 2019-12-29 20:00:00 | 2019-12-29T21:00:00+0100 | 48362.0 | 50508.0 | 0.0 | 50434.0 | 20610.0 | 30.47 | -1.015 | 0.00000 | 0.00000 | 1.75 | 68.91 |
| 2019-12-29 21:00:00 | 2019-12-29T22:00:00+0100 | 47950.0 | 50508.0 | 0.0 | 50434.0 | 21107.0 | 28.64 | -1.038 | 0.00000 | 0.00000 | 1.75 | 68.91 |
| 2019-12-29 22:00:00 | 2019-12-29T23:00:00+0100 | 45146.0 | 50508.0 | 0.0 | 50434.0 | 21740.0 | 23.06 | -1.079 | 0.00000 | 0.00000 | 1.75 | 68.91 |
| 2019-12-29 23:00:00 | 2019-12-30T00:00:00+0100 | 43026.0 | 50508.0 | 0.0 | 50452.0 | 22553.0 | 13.54 | -1.138 | 0.00000 | 0.00000 | 1.75 | 68.91 |
| 2019-12-30 00:00:00 | 2019-12-30T01:00:00+0100 | 41138.0 | 50508.0 | 0.0 | 50452.0 | 22793.0 | 11.42 | -1.162 | 0.00000 | 0.00000 | 2.06 | 68.30 |